package order.dao;

import order.pojo.manager;
import order.pojo.store_information;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class customerDao {
    //查询商家信息的发布状态
    public String querryPublisher(Connection con) throws SQLException {
        String sql="select store_publisher from store_information where store_id=1";
        PreparedStatement pstm=con.prepareStatement(sql);
        ResultSet rs=pstm.executeQuery();

     String publisher=null;
        while(rs.next()){
           publisher=rs.getString("store_publisher");
            System.out.println("商店发布状态："+publisher);

        }
        return publisher;

    }

}
